/*
MySQL Backup
Database: mumuda
Backup Time: 2025-06-15 15:52:31
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `mumuda`.`tt_email_config`;
DROP TABLE IF EXISTS `mumuda`.`tt_email_content`;
DROP TABLE IF EXISTS `mumuda`.`tt_email_template`;
CREATE TABLE `tt_email_config` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自增唯一编码',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '邮箱账号',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '邮箱密码',
  `host` varchar(255) DEFAULT NULL COMMENT 'SMTP邮箱服务器',
  `port` int DEFAULT NULL COMMENT 'SMTP邮件服务器默认端口',
  `protocol` varchar(255) DEFAULT NULL COMMENT '邮件协议',
  `sign` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '签名',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `status` tinyint(1) DEFAULT '0' COMMENT '状态 0 正常 1失效',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tt_email_content` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '唯一编码',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '发件箱',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `to_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '收件箱',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '内容',
  `status` tinyint(1) DEFAULT '0' COMMENT '发送状态 0 未发送 1 已发送 2 发送失败',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `deleted` tinyint DEFAULT '0' COMMENT '删除状态0 正常 1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tt_email_template` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '唯一编码',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `title` varchar(255) DEFAULT NULL COMMENT '主题',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '内容',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='邮件模板';
BEGIN;
LOCK TABLES `mumuda`.`tt_email_config` WRITE;
DELETE FROM `mumuda`.`tt_email_config`;
INSERT INTO `mumuda`.`tt_email_config` (`id`,`email`,`password`,`host`,`port`,`protocol`,`sign`,`create_time`,`update_time`,`status`) VALUES (12, 'mmdt2021@126.com', 'C5yxSfxLkuc9O72EZudbMgH0+Cv2vFfeb9/NO8Kt+qM=', 'smtp.126.com', 465, 'smtp', '<hr style=\"width: 210px; height: 1px;\" color=\"#b5c4df\" size=\"1\" align=\"left\">\n<div><span><div style=\"MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt\"><div><br></div><div><div style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\"><span style=\"background-color: transparent;\">Rong Zhang </span></div><div style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\"><img src=\"\" border=\"0\" width=\"332\" height=\"46.5\" class=\"image_zoomin\" style=\" cursor: url(#), pointer; max-width: 100%; height: auto !important; \"></div><div style=\"font-family: 微软雅黑; font-size: 14px;\"><div class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\"><span style=\"background-color: transparent;\"><b>Amass Leanway GmbH</b></span></div><div class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\">Monschauer Str. 12</div><div class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\">40549 Dusseldorf</div><div class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\">Germany</div><div class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\"><div class=\"\" style=\"position: static !important;\">UST-ID: DE364949252</div><div class=\"\" style=\"position: static !important;\">Re.No.:HRB102686</div></div><div class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\"><span style=\"color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);\">Mob: +86 18291840865</span></div><div class=\"\"><span class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\">E-Mail:</span><font face=\"Times New Roman\"><span style=\"font-size: 15px;\"><span class=\"\">&nbsp;</span><a style=\"color: #267EF0;\" href=\"mailto:rongzhang.sc@leanwayscm.com\" target=\"_blank\">rongzhang.sc@leanwayscm.com</a></span></font></div></div></div> </div></span></div>', '2024-09-27 14:46:35', '2024-09-29 16:09:44', 0),(15, 'rongzhang.sc@leanwayscm.com', 'AIDWKnL3ZYMmQnYuxLTd3wH0+Cv2vFfeb9/NO8Kt+qM=', 'smtp.exmail.qq.com', 465, 'smtp', '<hr style=\"width: 210px; height: 1px;\" color=\"#b5c4df\" size=\"1\" align=\"left\">\n<div><span><div style=\"MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt\"><div><br></div><div><div style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\"><span style=\"background-color: transparent;\">Rong Zhang </span></div><div style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\"><img src=\"\" border=\"0\" width=\"332\" height=\"46.5\" class=\"image_zoomin\" style=\" cursor: url(#), pointer; max-width: 100%; height: auto !important; \"></div><div style=\"font-family: 微软雅黑; font-size: 14px;\"><div class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\"><span style=\"background-color: transparent;\"><b>Amass Leanway GmbH</b></span></div><div class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\">Monschauer Str. 12</div><div class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\">40549 Dusseldorf</div><div class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\">Germany</div><div class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\"><div class=\"\" style=\"position: static !important;\">UST-ID: DE364949252</div><div class=\"\" style=\"position: static !important;\">Re.No.:HRB102686</div></div><div class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\"><span style=\"color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);\">Mob: +86 18291840865</span></div><div class=\"\"><span class=\"\" style=\"font-family: &quot;Times New Roman&quot;; font-size: 15px;\">E-Mail:</span><font face=\"Times New Roman\"><span style=\"font-size: 15px;\"><span class=\"\">&nbsp;</span><a style=\"color: #267EF0;\" href=\"mailto:rongzhang.sc@leanwayscm.com\" target=\"_blank\">rongzhang.sc@leanwayscm.com</a></span></font></div></div></div> </div></span></div>', '2024-09-27 15:52:02', '2024-09-29 16:22:33', 0),(16, 'mmdt2021@126.com', 'C5yxSfxLkuc9O72EZudbMgH0+Cv2vFfeb9/NO8Kt+qM=', 'smtp.126.com', 465, 'smtp', '', '2024-09-28 11:35:18', '2024-09-28 11:35:27', 1);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `mumuda`.`tt_email_content` WRITE;
DELETE FROM `mumuda`.`tt_email_content`;
INSERT INTO `mumuda`.`tt_email_content` (`id`,`email`,`title`,`to_email`,`content`,`status`,`create_time`,`update_time`,`deleted`) VALUES (34, 'rongzhang.sc@leanwayscm.com', 'Arrive Notice--BL NO.  COSU6391877100', 'rongzhang.sc@leanwayscm.com', '<p>Dear</p>\r\n<p><br />Your shipments will arrive at the port soon(BL No.and CTN NO.as below),&nbsp;<br />Please provide below information so we can issue the invoice.&nbsp;</p>\r\n<p><br />Company name---&nbsp;</p>\r\n<p>Company address----&nbsp;&nbsp;</p>\r\n<p>VAT----&nbsp;&nbsp;</p>\r\n<p><br />In addition, we have submitted the release application for this shipment,&nbsp;<br />Please advise to which company we should release.<br />Thank you. &nbsp; &nbsp;&nbsp;</p><br />COSU6391877100  BSIU9523273', 0, '2024-09-30 12:10:53', '2024-09-30 12:10:53', 0),(35, 'rongzhang.sc@leanwayscm.com', 'Arrive Notice--BL NO.  MEDUXD730636', 'rongzhang.sc@leanwayscm.com;mmdt2021@126.com', '<p>Dear</p>\r\n<p><br />Your shipments will arrive at the port soon(BL No.and CTN NO.as below),&nbsp;<br />Please provide below information so we can issue the invoice.&nbsp;</p>\r\n<p><br />Company name---&nbsp;</p>\r\n<p>Company address----&nbsp;&nbsp;</p>\r\n<p>VAT----&nbsp;&nbsp;</p>\r\n<p><br />In addition, we have submitted the release application for this shipment,&nbsp;<br />Please advise to which company we should release.<br />Thank you. &nbsp; &nbsp;&nbsp;</p><br />MEDUXD730636 177SNWNWN3U697A CAAU5660578<br />MEDUXD730636 177SNWNWN3U695A MSCU5360665 MSDU7637599<br />MEDUXD730636 177SNWNWN3U690A MSMU6217983 MSMU8683240 MSMU7940467 FCIU7010103 MEDU4621837', 0, '2024-09-30 12:10:53', '2024-09-30 12:10:53', 0),(36, 'rongzhang.sc@leanwayscm.com', 'Arrive Notice--BL NO.  COSU6392064110', 'mmdt2021@126.com', '<p>Dear</p>\r\n<p><br />Your shipments will arrive at the port soon(BL No.and CTN NO.as below),&nbsp;<br />Please provide below information so we can issue the invoice.&nbsp;</p>\r\n<p><br />Company name---&nbsp;</p>\r\n<p>Company address----&nbsp;&nbsp;</p>\r\n<p>VAT----&nbsp;&nbsp;</p>\r\n<p><br />In addition, we have submitted the release application for this shipment,&nbsp;<br />Please advise to which company we should release.<br />Thank you. &nbsp; &nbsp;&nbsp;</p><br />COSU6392064110 COSU6392063830 TIIU5734110 TIIU4958218', 1, '2024-09-30 12:10:53', '2024-09-30 12:11:21', 0),(37, 'mmdt2021@126.com', 'Arrive Notice--BL NO.  COSU6391877100', 'rongzhang.sc@leanwayscm.com', '<p>Dear</p>\r\n<p><br />Your shipments will arrive at the port soon(BL No.and CTN NO.as below),&nbsp;<br />Please provide below information so we can issue the invoice.&nbsp;</p>\r\n<p><br />Company name---&nbsp;</p>\r\n<p>Company address----&nbsp;&nbsp;</p>\r\n<p>VAT----&nbsp;&nbsp;</p>\r\n<p><br />In addition, we have submitted the release application for this shipment,&nbsp;<br />Please advise to which company we should release.<br />Thank you. &nbsp; &nbsp;&nbsp;</p><br />COSU6391877100  BSIU9523273', 0, '2024-09-30 12:15:13', '2024-09-30 12:15:13', 0),(38, 'mmdt2021@126.com', 'Arrive Notice--BL NO.  MEDUXD730636', 'rongzhang.sc@leanwayscm.com;mmdt2021@126.com', '<p>Dear</p>\r\n<p><br />Your shipments will arrive at the port soon(BL No.and CTN NO.as below),&nbsp;<br />Please provide below information so we can issue the invoice.&nbsp;</p>\r\n<p><br />Company name---&nbsp;</p>\r\n<p>Company address----&nbsp;&nbsp;</p>\r\n<p>VAT----&nbsp;&nbsp;</p>\r\n<p><br />In addition, we have submitted the release application for this shipment,&nbsp;<br />Please advise to which company we should release.<br />Thank you. &nbsp; &nbsp;&nbsp;</p><br />MEDUXD730636 177SNWNWN3U697A CAAU5660578<br />MEDUXD730636 177SNWNWN3U695A MSCU5360665 MSDU7637599<br />MEDUXD730636 177SNWNWN3U690A MSMU6217983 MSMU8683240 MSMU7940467 FCIU7010103 MEDU4621837', 1, '2024-09-30 12:15:13', '2024-09-30 12:15:21', 0),(39, 'mmdt2021@126.com', 'Arrive Notice--BL NO.  COSU6392064110', 'mmdt2021@126.com', '<p>Dear</p>\r\n<p><br />Your shipments will arrive at the port soon(BL No.and CTN NO.as below),&nbsp;<br />Please provide below information so we can issue the invoice.&nbsp;</p>\r\n<p><br />Company name---&nbsp;</p>\r\n<p>Company address----&nbsp;&nbsp;</p>\r\n<p>VAT----&nbsp;&nbsp;</p>\r\n<p><br />In addition, we have submitted the release application for this shipment,&nbsp;<br />Please advise to which company we should release.<br />Thank you. &nbsp; &nbsp;&nbsp;</p><br />COSU6392064110 COSU6392063830 TIIU5734110 TIIU4958218', 0, '2024-09-30 12:15:13', '2024-09-30 12:15:13', 0);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `mumuda`.`tt_email_template` WRITE;
DELETE FROM `mumuda`.`tt_email_template`;
INSERT INTO `mumuda`.`tt_email_template` (`id`,`email`,`title`,`content`,`create_time`,`update_time`) VALUES (1, 'mmdt2021@126.com', 'Arrive Notice--BL NO. ', '<p>Dear</p>\r\n<p><br />Your shipments will arrive at the port soon(BL No.and CTN NO.as below),&nbsp;<br />Please provide below information so we can issue the invoice.&nbsp;</p>\r\n<p><br />Company name---&nbsp;</p>\r\n<p>Company address----&nbsp;&nbsp;</p>\r\n<p>VAT----&nbsp;&nbsp;</p>\r\n<p><br />In addition, we have submitted the release application for this shipment,&nbsp;<br />Please advise to which company we should release.<br />Thank you. &nbsp; &nbsp;&nbsp;</p><br />', '2024-09-30 11:05:43', '2024-09-30 11:21:33'),(2, 'rongzhang.sc@leanwayscm.com', 'Arrive Notice--BL NO. ', '<p>Dear</p>\r\n<p><br />Your shipments will arrive at the port soon(BL No.and CTN NO.as below),&nbsp;<br />Please provide below information so we can issue the invoice.&nbsp;</p>\r\n<p><br />Company name---&nbsp;</p>\r\n<p>Company address----&nbsp;&nbsp;</p>\r\n<p>VAT----&nbsp;&nbsp;</p>\r\n<p><br />In addition, we have submitted the release application for this shipment,&nbsp;<br />Please advise to which company we should release.<br />Thank you. &nbsp; &nbsp;&nbsp;</p><br />', '2024-09-30 11:05:43', '2024-09-30 11:21:35');
UNLOCK TABLES;
COMMIT;
